SheetAdd_ANmar

Adds a sheet to a workbook, after checking if workbook is open Checks if ...

SheetName

Gets a sheet name by referencing sheet ID or Sheet No This is more likely to ...

Page2Setting

Read content of an html online page into setting value in Excel sheet. ...

CopyFormat

Applies format into a cell (or range) from another cell. Can apply from any ...

SheetDelete_ANmar

Deletes a sheet from a workbook, checks it is already there first

CellSave_Hyperlink

Creates a hyperlink to URL or to cell inside a cell in Excel VBA (or delete it). ...

Sheets to PDF pages

Export multiple sheets as pages in 1 pdf, doc, still rough and not elegant as ...

WelcomeSheet

A User-Friendly way to ask user to enable macros. Showing an only sheet to let ...

WelcomeSheet.zip

XLThumbView

Showing thumbnails inside sheet and enlarging each when click

XLThumbview.zip

LoadPicture_Safe

Loads an image into VBA image control without knowing its extension If file ...

SortArea1

Sorts a range or area by 1 column given its cell address, with options to ...

Page area and Page Setup functions (Unfinished)

Clear Excel print area, or set it, or read it, along with Page setup commands ...